File Format for Importing Apportionment Mapping

The CSV file must contain comma separate columns and optionally can have quotes around string values.

The first row can be a column header, which is optional. If you do use one, it needs to follow the order in the following table:

Column	Column Name
1	Target Project
2	Resource
3	Target CA1
4	Target CA2
5	Target CA3
6	Target WP
7	Rate Set
8	Source Project
9	Source CA1
10	Source CA2
11	Source CA3

Different columns must be filled in depending on what you are importing. The following validations take place:

• If the specified project is a master project, the projects named in Column 1 (Target Project) and Column 8 (Source Project) must both exist as a subproject of the specified master project.
• If the specified project is not a master project, the projects named in Column 1 (Target Project) and Column 8 (Source Project) must be the same as the name of the specified project.
• The resource in Column 2 must be a valid resource with apportionment defined in the resource file of the specified project.
• The data in Columns 3–6 (Target CA/WP) must exist in the target project if Column 3 is not <Same As Source>. If Column 3 is <Same As Source>, any data in Columns 4–6 is ignored.
  Note: <Same As Source> is case sensitive.
• The data in Columns 9–11 (Source CA) must exist in the source project if Column 9 is not <All>. If Column 9 is <All>, any data in Columns 10–11 is ignored.
  Note: <All> is case sensitive.
• The rate set in Column 7 is checked to see if it exists in the rate file for the specified project, but the data is imported anyway if not found.